﻿DROP TABLE IF EXISTS `open_group_promotion_gallery`;
CREATE TABLE `open_group_promotion_gallery` (
  `img_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `group_promotion_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `img_url` varchar(255) NOT NULL DEFAULT '',
  `img_desc` varchar(255) NOT NULL DEFAULT '',
  `thumb_url` varchar(255) NOT NULL DEFAULT '',
  `img_original` varchar(255) NOT NULL DEFAULT '',
  `is_reveal` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`img_id`),
  KEY `group_promotion_id` (`group_promotion_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;